<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos  -->
			<title>File Source for TodoListModel.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
											</head>
		<body>
						<h1>Source for file TodoListModel.php</h1>
<p>Documentation is available at <a href="../default/_ays_application_model_TodoListModel_php.html">TodoListModel.php</a></p>
<div class="src-code">
<pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><a href="../default/_ays_application_function_protectScript_php.html#functionprotectScript">protectScript</a><span class="src-sym">(</span><span class="src-str">'TodoListModel.php'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a3"></a>&nbsp;</li>
<li><a name="a4"></a><span class="src-key">class </span><a href="../default/TodoListModel.html">TodoListModel</a><span class="src-sym">{</span></li>
<li><a name="a5"></a>    <span class="src-key">private </span><span class="src-key">static </span><span class="src-var">$_asmReadOnlyProps </span>= <span class="src-key">array</span><span class="src-sym">(</span></li>
<li><a name="a6"></a>        <span class="src-str">'sTableName' </span>=&gt; <span class="src-str">'task'</span><span class="src-sym">,</span></li>
<li><a name="a7"></a>        <span class="src-str">'sTablePrefix' </span>=&gt; <span class="src-id">TABLE_PREFIX</span></li>
<li><a name="a8"></a>    <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a9"></a>&nbsp;</li>
<li><a name="a10"></a>    <span class="src-key">private </span><a href="../default/TodoListModel.html#var$_asmWritableProps">$_asmWritableProps</a> = <span class="src-key">array</span><span class="src-sym">(</span></li>
<li><a name="a11"></a>        <span class="src-str">'iIdTask' </span>=&gt; <span class="src-num">0</span><span class="src-sym">,</span></li>
<li><a name="a12"></a>        <span class="src-str">'iDateBeginTask' </span>=&gt; <span class="src-num">0</span><span class="src-sym">,</span></li>
<li><a name="a13"></a>        <span class="src-str">'iDateEndTask' </span>=&gt; <span class="src-num">0</span><span class="src-sym">,</span></li>
<li><a name="a14"></a>        <span class="src-str">'sLabelTask' </span>=&gt; <span class="src-str">''</span><span class="src-sym">,</span></li>
<li><a name="a15"></a>        <span class="src-str">'sDescriptionTask' </span>=&gt; <span class="src-str">''</span><span class="src-sym">,</span></li>
<li><a name="a16"></a>        <span class="src-str">'iStatusTask' </span>=&gt; <span class="src-num">1</span><span class="src-sym">,</span></li>
<li><a name="a17"></a>        <span class="src-str">'iPriorityTask' </span>=&gt; <span class="src-num">0</span></li>
<li><a name="a18"></a>    <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a19"></a>&nbsp;</li>
<li><a name="a20"></a>    <span class="src-key">const </span><span class="src-id">TODO </span>= <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a21"></a>    <span class="src-key">const </span><span class="src-id">DONE </span>= <span class="src-num">2</span><span class="src-sym">;</span></li>
<li><a name="a22"></a>    <span class="src-key">const </span><span class="src-id">DOIN </span>= <span class="src-num">3</span><span class="src-sym">;</span></li>
<li><a name="a23"></a>&nbsp;</li>
<li><a name="a24"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-var">$asmTodoListInfo </span>= <span class="src-id">null</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a25"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iIdTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'idTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'idTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iIdTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a26"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iDateBeginTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'dateBeginTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'dateBeginTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iDateBeginTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a27"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iDateEndTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'dateEndTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'dateEndTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iDateEndTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a28"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'sLabelTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'labelTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'labelTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'sLabelTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a29"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'sDescriptionTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'descriptionTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'descriptionTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'sDescriptionTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a30"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iStatusTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'statusTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'statusTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iStatusTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a31"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iPriorityTask'</span><span class="src-sym">] </span>= <span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'priorityTask'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$asmTodoListInfo</span><span class="src-sym">[</span><span class="src-str">'priorityTask'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-str">'iPriorityTask'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a32"></a>    <span class="src-sym">}</span></li>
<li><a name="a33"></a>&nbsp;</li>
<li><a name="a34"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodgetTasks">getTasks</a><span class="src-sym">(</span><span class="src-var">$sWhereClause </span>= <span class="src-id">null</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a35"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id"><a href="../default/AYSMysqli.html">AYSMysqli</a></span><span class="src-sym">::</span><a href="../default/AYSMysqli.html#methodgetInstance">getInstance</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a36"></a>&nbsp;</li>
<li><a name="a37"></a>        <span class="src-key">if</span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$sWhereClause</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a38"></a>            <span class="src-var">$sWhere </span>= <span class="src-str">&quot;</span><span class="src-str"><span class="src-var">$sWhereClause</span></span><span class="src-str">&quot;</span><span class="src-sym">;</span></li>
<li><a name="a39"></a>        <span class="src-sym">}</span><span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a40"></a>            <span class="src-var">$sWhere </span>= <span class="src-str">''</span><span class="src-sym">;</span></li>
<li><a name="a41"></a>        <span class="src-sym">}</span></li>
<li><a name="a42"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a43"></a>            <span class="src-str">'SELECT idTask, dateBeginTask, dateEndTask, labelTask, descriptionTask, statusTask, priorityTask ' </span>.</li>
<li><a name="a44"></a>            <span class="src-str">&quot;FROM %s &quot; </span>. <span class="src-var">$sWhere </span>. <span class="src-str">&quot; ORDER BY priorityTask&quot;</span><span class="src-sym">,</span></li>
<li><a name="a45"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span></li>
<li><a name="a46"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a47"></a>        <span class="src-var">$rQueryResult </span>= <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a48"></a>&nbsp;</li>
<li><a name="a49"></a>        <span class="src-var">$aiasmTasksList </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a50"></a>        <span class="src-key">while</span><span class="src-sym">(</span><span class="src-var">$r </span>= <span class="src-var">$rQueryResult</span><span class="src-sym">-&gt;</span><span class="src-id">fetch_assoc</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a51"></a>            <span class="src-var">$aiasmTasksList</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$r</span><span class="src-sym">;</span></li>
<li><a name="a52"></a>        <span class="src-sym">}</span></li>
<li><a name="a53"></a>        <span class="src-key">return </span><span class="src-var">$aiasmTasksList</span><span class="src-sym">;</span></li>
<li><a name="a54"></a>    <span class="src-sym">}</span></li>
<li><a name="a55"></a>&nbsp;</li>
<li><a name="a56"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodupdateStatus">updateStatus</a><span class="src-sym">(</span><span class="src-var">$iIdTask</span><span class="src-sym">, </span><span class="src-var">$iTaskStatus</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a57"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a58"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a59"></a>            <span class="src-str">&quot;UPDATE %s &quot; </span>.</li>
<li><a name="a60"></a>            <span class="src-str">&quot;SET statusTask = %d&quot; </span>.</li>
<li><a name="a61"></a>            <span class="src-str">&quot;WHERE idTask = %d&quot;</span><span class="src-sym">,</span></li>
<li><a name="a62"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a63"></a>            <span class="src-var">$iTaskStatus</span><span class="src-sym">,</span></li>
<li><a name="a64"></a>            <span class="src-var">$iIdTask</span></li>
<li><a name="a65"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a66"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a67"></a>    <span class="src-sym">}</span></li>
<li><a name="a68"></a>&nbsp;</li>
<li><a name="a69"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodupdatePriority">updatePriority</a><span class="src-sym">(</span><span class="src-var">$iIdTask</span><span class="src-sym">, </span><span class="src-var">$iTaskPriority</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a70"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a71"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a72"></a>            <span class="src-str">&quot;UPDATE %s &quot; </span>.</li>
<li><a name="a73"></a>            <span class="src-str">&quot;SET priorityTask = %d&quot; </span>.</li>
<li><a name="a74"></a>            <span class="src-str">&quot;WHERE idTask = %d&quot;</span><span class="src-sym">,</span></li>
<li><a name="a75"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a76"></a>            <span class="src-var">$iTaskPriority</span><span class="src-sym">,</span></li>
<li><a name="a77"></a>            <span class="src-var">$iIdTask</span></li>
<li><a name="a78"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a80"></a>    <span class="src-sym">}</span></li>
<li><a name="a81"></a>&nbsp;</li>
<li><a name="a82"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodupdateDate">updateDate</a><span class="src-sym">(</span><span class="src-var">$iIdTask</span><span class="src-sym">, </span><span class="src-var">$sTypeDate</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a83"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a84"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a85"></a>            <span class="src-str">&quot;UPDATE %s &quot; </span>.</li>
<li><a name="a86"></a>            <span class="src-str">&quot;SET %s = NOW()&quot; </span>.</li>
<li><a name="a87"></a>            <span class="src-str">&quot;WHERE idTask = %d&quot;</span><span class="src-sym">,</span></li>
<li><a name="a88"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a89"></a>            <span class="src-var">$sTypeDate</span><span class="src-sym">,</span></li>
<li><a name="a90"></a>            <span class="src-var">$iIdTask</span></li>
<li><a name="a91"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a92"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a93"></a>    <span class="src-sym">}</span></li>
<li><a name="a94"></a>&nbsp;</li>
<li><a name="a95"></a>    <span class="src-key">public </span><span class="src-key">static </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodaddTask">addTask</a><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a96"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a97"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a98"></a>            <span class="src-str">&quot;INSERT INTO %s (labelTask, descriptionTask, statusTask, priorityTask)&quot;</span>.</li>
<li><a name="a99"></a>            <span class="src-str">&quot;VALUES ('%s', '%s', %d, %d)&quot;</span><span class="src-sym">,</span></li>
<li><a name="a100"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a101"></a>            <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">escape_string</span><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'labelTask'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a102"></a>            <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">escape_string</span><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'descriptionTask'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a103"></a>            <span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'statusTask'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a104"></a>            <span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'priorityTask'</span><span class="src-sym">]</span></li>
<li><a name="a105"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a106"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a107"></a>    <span class="src-sym">}</span></li>
<li><a name="a108"></a>&nbsp;</li>
<li><a name="a109"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methodeditTask">editTask</a><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a110"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a111"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a112"></a>            <span class="src-str">&quot;UPDATE %s &quot;</span>.</li>
<li><a name="a113"></a>            <span class="src-str">&quot;SET labelTask = '%s', descriptionTask = '%s', statusTask = %d, priorityTask = %d &quot;</span>.</li>
<li><a name="a114"></a>            <span class="src-str">&quot;WHERE idTask = %d&quot;</span><span class="src-sym">,</span></li>
<li><a name="a115"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a116"></a>            <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">escape_string</span><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'labelTask'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a117"></a>            <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">escape_string</span><span class="src-sym">(</span><span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'descriptionTask'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a118"></a>            <span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'statusTask'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a119"></a>            <span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'priorityTask'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a120"></a>            <span class="src-var">$assTaskInfos</span><span class="src-sym">[</span><span class="src-str">'idTask'</span><span class="src-sym">]</span></li>
<li><a name="a121"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a122"></a>&nbsp;</li>
<li><a name="a123"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a124"></a>    <span class="src-sym">}</span></li>
<li><a name="a125"></a>&nbsp;</li>
<li><a name="a126"></a>    <span class="src-key">public </span><span class="src-key">static </span><span class="src-key">function </span><a href="../default/TodoListModel.html#methoddelTask">delTask</a><span class="src-sym">(</span><span class="src-var">$iIdTask</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a127"></a>        <span class="src-var">$oMysqliInstance </span>= <span class="src-id">AYSMysqli</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a128"></a>        <span class="src-var">$query </span>= <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span></li>
<li><a name="a129"></a>            <span class="src-str">&quot;DELETE FROM %s &quot;</span>.</li>
<li><a name="a130"></a>            <span class="src-str">&quot;WHERE idTask = %d&quot;</span><span class="src-sym">,</span></li>
<li><a name="a131"></a>            <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTablePrefix'</span><span class="src-sym">]</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$_asmReadOnlyProps</span><span class="src-sym">[</span><span class="src-str">'sTableName'</span><span class="src-sym">]</span><span class="src-sym">,</span></li>
<li><a name="a132"></a>            <span class="src-var">$iIdTask</span></li>
<li><a name="a133"></a>        <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a134"></a>        <span class="src-var">$oMysqliInstance</span><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a135"></a>    <span class="src-sym">}</span></li>
<li><a name="a136"></a>&nbsp;</li>
<li><a name="a137"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#method__get">__get</a><span class="src-sym">(</span><span class="src-var">$sVariableName</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a138"></a>        <span class="src-key">if</span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a139"></a>            <span class="src-key">if</span><span class="src-sym">(</span><span class="src-id">is_array</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a140"></a>                <span class="src-key">return </span>clone <span class="src-key">new </span><span class="src-id">ArrayObject</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a141"></a>            <span class="src-sym">}</span><span class="src-key">elseif</span><span class="src-sym">(</span><a href="http://www.php.net/is_object">is_object</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a142"></a>                <span class="src-key">return </span>clone <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a143"></a>            <span class="src-sym">}</span><span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a144"></a>                <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a145"></a>            <span class="src-sym">}</span></li>
<li><a name="a146"></a>        <span class="src-sym">}</span><span class="src-key">elseif</span><span class="src-sym">(</span><span class="src-sym">!</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a147"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">] </span>= <span class="src-id">NULL</span><span class="src-sym">;</span></li>
<li><a name="a148"></a>        <span class="src-sym">}</span></li>
<li><a name="a149"></a>&nbsp;</li>
<li><a name="a150"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a151"></a>    <span class="src-sym">}</span></li>
<li><a name="a152"></a>&nbsp;</li>
<li><a name="a153"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../default/TodoListModel.html#method__set">__set</a><span class="src-sym">(</span><span class="src-var">$sVariableName</span><span class="src-sym">, </span><span class="src-var">$mValueVariable</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a154"></a>        <span class="src-key">if</span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmReadOnlyProps">_asmReadOnlyProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">]</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a155"></a>            throw <span class="src-key">new </span><span class="src-id"><a href="../default/SetReadOnlyPropsException.html">SetReadOnlyPropsException</a></span><span class="src-sym">(</span></li>
<li><a name="a156"></a>                <span class="src-str">'Tried to set a read only property on the event object'</span><span class="src-sym">,</span></li>
<li><a name="a157"></a>                <span class="src-id"><a href="../default/_ays_application_Exceptions_ExceptionsList_php.html#defineERROR">ERROR</a></span><span class="src-sym">,</span></li>
<li><a name="a158"></a>                <span class="src-key">array</span><span class="src-sym">(</span></li>
<li><a name="a159"></a>                    <span class="src-str">'scriptName' </span>=&gt; <span class="src-str">'TodoListModel.php'</span><span class="src-sym">,</span></li>
<li><a name="a160"></a>                    <span class="src-str">'variableName' </span>=&gt; <span class="src-var">$sVariableName</span></li>
<li><a name="a161"></a>                <span class="src-sym">)</span></li>
<li><a name="a162"></a>            <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a163"></a>        <span class="src-sym">}</span></li>
<li><a name="a164"></a>&nbsp;</li>
<li><a name="a165"></a>        <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../default/TodoListModel.html#var$_asmWritableProps">_asmWritableProps</a><span class="src-sym">[</span><span class="src-var">$sVariableName</span><span class="src-sym">] </span>= <span class="src-var">$mValueVariable</span><span class="src-sym">;</span></li>
<li><a name="a166"></a>    <span class="src-sym">}</span></li>
<li><a name="a167"></a><span class="src-sym">}</span></li>
</ol></pre>
</div>
	<p class="notes" id="credit">
		Documentation generated on Sun, 30 Mar 2008 00:13:59 +0100 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC3</a>
	</p>
	</body>
</html>